SELECT S_Articles.UID AS UID,
S_Articles.Modified AS Modified,
S_Articles.Name AS Name,
S_Articles.PreTitle AS PreTitle,
S_Articles.Description AS Description,
S_ItemsCategories.ItemsCategoriesModeID AS ItemsCategoriesModeID,
S_Articles.HTML AS HTML, CASE
WHEN NOT S_Articles.HTML IS NULL AND N''>'' THEN
dbo.S_MarkPhrases((SELECT Text FROM dbo.S_RemoveTags(S_Articles.HTML) FOR XML RAW('a')), N'', '', '')
ELSE NULL END AS MarkedHTML,
[dbo].S_GetItemAttributesList(3, S_Articles.UID) AS AttributesList, CASE WHEN TitleLogoPictures.FileName>'' THEN '../UserFiles90/'+TitleLogoPictures.FileName ELSE '' END AS TitleLogoPictureFileName
FROM S_Articles
INNER JOIN S_ItemsCategories ON (S_ItemsCategories.ItemTypeID=3 AND S_Articles.UID=S_ItemsCategories.ItemUID)
LEFT JOIN S_Pictures AS TitleLogoPictures ON S_Articles.TitleLogoPictureUID=TitleLogoPictures.UID
WHERE S_ItemsCategories.ShopID=90
AND S_Articles.IsActive <> 0
AND S_Articles.ShopID = 90 AND S_ItemsCategories.CategoryUID = '{B7AE95B6-F7B0-49B4-A6AA-15FD92B07CCD}' ORDER BY S_ItemsCategories.[Index]
ניתן לארח אתר אינטרנט על גבי השרתים שלנו במחיר
אטרקטיבי במיוחד ובשרות אישי.
